USE [BMIG_MENSUAL_POST_CADENA]
GO

 -- creating the store procedure
IF EXISTS (SELECT name FROM sysobjects WHERE  name = '[dbo].[WASP_M0006_LIMPIA_TABLAS]' AND type = 'P') 
	DROP PROCEDURE WASP_M0006_LIMPIA_TABLAS
GO

CREATE PROCEDURE [dbo].[WASP_M0006_LIMPIA_TABLAS] AS 
begin
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[as_colocacion_mensual_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  BEGIN  
    DROP TABLE [dbo].[as_colocacion_mensual_temp]
  END  
END
GO